A SQL Escape Sequences

Language features, such as outer joins and scalar function calls, are commonly implemented by database systems. The syntax for these features is often database-specific, even when a standard syntax has been defined. ODBC and JDBC define escape sequences that contain standard syntaxes for the language features in Table A-1.

NOTE: The .NET data provider supports ODBC/JDBC SQL escape sequences, except where otherwise noted.

Table A-1. Language Features 

Language Feature	SequeLink Client for ODBC	SequeLink Client for JDBC	SequeLink Client for .NET
Date, time, and timestamp literals	X	X	X
Scalar functions such as numeric, string, and date type conversion functions	X	X	X
LIKE predicate escape characters	X	X
Outer joins	X	X	X
Procedure call escape sequences	X	X

The escape sequence is recognized and parsed by the driver or data provider, which replaces the escape sequences with data store-specific grammar.